CREATE OR REPLACE PROCEDURE list_products_static 
  (p_product_name VARCHAR2 DEFAULT NULL)
AS
  v_bind  VARCHAR2(400);
BEGIN
  v_bind := '%'||p_product_name||'%';
  FOR i in 
    (SELECT product_name, min_price, list_price 
     FROM product_information
     WHERE product_name like v_bind)
  LOOP
      DBMS_OUTPUT.PUT_LINE('Product Info: '||i.product_name ||',
         '|| i.min_price ||', '|| i.list_price);
  END LOOP;
END list_products_static;
/
